package com.server.pinggu.mapper;

import com.alibaba.fastjson.JSONObject;
import com.server.common.core.mapper.MpBaseMapper;
import com.server.pinggu.domain.SenForms;
import com.server.pinggu.upload.SenFormFieldsValue;
import com.server.pinggu.upload.SenFormsDownloadExcel;
import com.server.pinggu.upload.SenFormsDownloadExcel2;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 【请填写功能名称】Mapper接口
 * 
 * @author ltao
 * @date 2022-10-23
 */
public interface SenFormsMapper extends MpBaseMapper<SenForms>
{
    /**
     * 查询【请填写功能名称】列表
     *
     * @param senForms 【请填写功能名称】
     * @return 【请填写功能名称】集合
     */
    public List<SenForms> selectSenFormsList(@Param("senForms") SenForms senForms,@Param("sqsjFront") Integer sqsjFront,@Param("sqsjBack") Integer sqsjBack
    ,@Param("list") List<String> list);

    int updateImageById(@Param("obj") JSONObject jsonObject);

    List<JSONObject> selectByPgrIdFront(@Param("uid") List<Long> uid);
    List<JSONObject> selectByPgrIdQueen(@Param("uid") List<Long> uid);
    List<JSONObject> selectAllPgyFront(@Param("id") Long id);
    List<JSONObject> selectAllPgyQueen(@Param("id") Long id);


    List<SenFormsDownloadExcel> formsDownloadExcel(@Param("senForms") SenForms senForms,@Param("sqsjFront") Integer sqsjFront,@Param("sqsjBack") Integer sqsjBack
            ,@Param("list") List<String> list);

    Integer selectSenFormsList2Total(
            @Param("senForms") SenForms senForms,@Param("sqsjFront") Integer front,@Param("sqsjBack")Integer blck,@Param("list")List<String> list
    );

    List<SenFormFieldsValue> formsDownloadValueExcel(@Param("id") Long id);

    List<JSONObject> queryFiltration(@Param("pingname")String pingname,@Param("list") List<String> list,@Param("sqsjFront")String sqsjFront,@Param("sqsjBack")String sqsjBack);

    List<SenFormsDownloadExcel2> formsDownloadExcel2(@Param("senForms") SenForms senForms,@Param("sqsjFront") Integer sqsjFront,@Param("sqsjBack") Integer sqsjBack
            ,@Param("list") List<String> list);
}
